﻿CREATE PROCEDURE [dbo].[GetEntryDetailsForUser]
@userID INT
AS
select e.* from EntryLog  e
inner join Projects p on p.ProjectID = e.ProjectID
where userID = 1 and p.ProjectTypeID <> 3 and p.StatusID = 1 and HasBeenBilled = 0

